mysqlblobsize

ThefourBLOBtypesareTINYBLOB,BLOB,MEDIUMBLOB,andLONGBLOB.Thesedifferonlyinthemaximumlengthofthevaluestheycanhold.ThefourTEXTtypes ...,Theinternalrepresentationofatablehasamaximumrowsizeof65,535bytes,evenifthestorageengineiscapableofsupportinglargerrows.Thisfigure ...,It's64kforaregularBLOB.Ifyouneedlarger,useMEDIUMBLOBorLONGBLOB(upto4GB).,2020年9月13日—InnoDBhas8bytesforlength,butonlylast4bytes...

參考資訊如下
13.3.4 The BLOB and TEXT Types

The four BLOB types are TINYBLOB , BLOB , MEDIUMBLOB , and LONGBLOB . These differ only in the maximum length of the values they can hold. The four TEXT types ...

13.7 Data Type Storage Requirements

The internal representation of a table has a maximum row size of 65,535 bytes, even if the storage engine is capable of supporting larger rows. This figure ...

MariaDB

It's 64k for a regular BLOB. If you need larger, use MEDIUMBLOB or LONGBLOB (up to 4GB).

Should I store BLOB length in my MySQLMariaDB table?

2020年9月13日 — InnoDB has 8 bytes for length, but only last 4 bytes are used, regardless of the blob type. – Georg Richter. Sep ...

What is the maximum length of data I can put in a BLOB ...

2011年4月25日 — A BLOB can be 65535 bytes (64 KB) maximum. If you need more consider using: a MEDIUMBLOB for 16777215 bytes (16 MB).

MySQL BLOB data types

2019年10月8日 — MEDIUMBLOB: Maximum length of 16777215 (2^24 - 1) bytes, or 16MB in storage. Each MEDIUMBLOB value is stored using a three-byte length prefix ...

How to Work with BLOB in MySQL Database Hosted on ...

2018年12月12日 — MEDIUMBLOB: The maximum length supported is 16,777,215 bytes. LONGBLOB: Stores up to 4,294,967,295 bytes of data. So before, we design the ...

How to Test BLOB from MySQL

What is the maximum length of data we can put in a BLOB ...

2020年6月20日 — What is the maximum length of data we can put in a BLOB column in MySQL? · 1 byte. BLOB, Up to 64 Kb · 2 bytes. MEDIUMBLOB, Up to 16 Mb · 3 bytes.

How to get size of BLOB in MySQL

2012年12月23日 — Recently I wanted to get the size of the data stored in the BLOB field of a MySQL table. BLOB is a field which can be used to store variable ...